Japanese weather report

SELECT video.id,video.titre_fr,video.time,video.note,video.bestimg,video.version,video.code,video.titre_en,video.hd,video.format FROM video,cat,video_cat WHERE video.date <= '2025-06-15' and video.id=video_cat.id_video AND cat.id=video_cat.id_cat AND cat.code='jessi-june' and video.version > 4 and video.version != 6 and video.version and video.best3 = 1 and video.hd = 3 and video.isdel=0 and video.del_fr=0 and video.id != 74720 ORDER BY rand() LIMIT 30